gsm_menu_structure table — gsmms
This table defines the dynamic menu structures available. A menu structure must belong to a product, and if required, can be associated with a product module for sorting purposes. The menu structure code is referenced in source code to build any dynamic menu items associated with the menu structure.
Table 7–7 lists the table’s FLA, fields, and foreign keys.
Table 7–7: gsm_menu_structure table information
|
Table FLA
|
Fields (data type)
|
Foreign keys
|
|
gsmms
|
menu_structure_obj (Decimal)
product_module_obj (Decimal)
product_obj (Decimal)
menu_structure_code (Character)
menu_structure_description (Character)
disabled (Logical)
system_owned (Logical)
under_development (Logical)
menu_item_obj (Decimal)
menu_structure_type (Character)
menu_structure_hidden (Logical)
control_spacing (Integer)
control_padding (Integer)
menu_structure_narrative (Character)
|
menu_item_obj
menu_structure_obj
product_module_obj
product_obj
|
Table 7–8 gives details of the table’s indexes.
Table 7–8: gsm_menu_structure index information
|
Index name
|
Elements
|
Type
|
|
XPKgsm_menu_structure
|
menu_structure_obj
|
Primary Unique
|
|
XAK1gsm_menu_structure
|
menu_structure_code
|
Unique
|
|
XAK2gsm_menu_structure
|
product_module_obj
menu_structure_code
|
Unique
|
|
XIE2gsm_menu_structure
|
menu_structure_description
|
Nonunique
|
|
XIE3gsm_menu_structure
|
menu_structure_type
|
Nonunique
|
|
XIE4gsm_menu_structure
|
menu_item_obj
|
Nonunique
|